﻿CREATE TABLE [dbo].[User] (
    [ID]           INT           IDENTITY (1, 1) NOT NULL,
    [Code]         NVARCHAR (10) NOT NULL,
    [Name]         NVARCHAR (50) NOT NULL,
    [Telephone]    NVARCHAR (50) NULL,
    [Cellphone]    NVARCHAR (50) NULL,
    [QQ]           NVARCHAR (50) NULL,
    [MSN]          NVARCHAR (50) NULL,
    [Address]      NVARCHAR (50) NULL,
    [Gender]       NVARCHAR (5)  NULL,
    [Passsword]    NVARCHAR (50) NOT NULL,
    [RoleId]       INT           NOT NULL,
    [CreatedDate]  DATETIME      NOT NULL,
    [CreatedBy]    INT           NOT NULL,
    [ModifiedDate] DATETIME      NOT NULL,
    [ModifiedBy]   INT           NOT NULL
);

